| |
|
Testing Data Generator for Relational Databases
Bašta, Jiří ; Rychlý, Marek (referee) ; Burget, Radek (advisor)
Testing of systems and applications is part of their development and therefore , testing data generation is very important . Test data generator according to a previously created template is as a tool for inserting test data to the database tables . This software allows developers or administrators to effectively test various systems that use the database storage . Data generation is carried out according to a pre - created template that defines the structure of database tables . The thesis describes the related topics of database systems and the process of the apllication implementation .
|
|
Digital factory in the company Ravensburger Kraton s.r.o.
Kusý, Jan ; Kaczmarczyk, Václav (referee) ; Benešl, Tomáš (advisor)
Bachelor’s thesis discusses the analysis of the term digital factory and the related initiative Industry 4.0. The work is processed in cooperation with the company Ravensburger Karton s.r.o. based in Polička and part of the work is devoted to its description. Furthermore, an analysis of the current production monitoring system, which is based on the WorkMonitor monitoring device from company Papouch, is processed. The main goal of this work is to design and manufacture monitoring devices communicating both on the WiFi interface and using an Ethernet cable. The individual ideas of design and production of both devices are described. Finally, an analysis of the advantages and disadvantages of the solution is performed, including a price comparison with the devices listed in the Market Research chapter.
|
| |
|
Comparison of Databases Systems for the Registers Digitalization
Rešovský, Martin ; Rozman, Jaroslav (referee) ; Kočí, Radek (advisor)
This paper presents comparative analysis of relational and object-based database systems over firmly specified data set gathered by registers digitalization of wedding and death records. Data were processed by chosen representants of theirs categories Db4o and PostgreSQL. Data model was created and described for both databases. Evaluation was made on the base of comparison of theoretical foundations, implementation and results of performance tests of the databases on test dataset equivalent to original sample. By carried out research, we found out, that relational model has stronger theoretical foundations, much better support and administration, and is more efficient. On the other hand, object-based approach models database much more naturally and preced construction complications. Main result is, that relational database model appears to be more efficient and preferable, and therefore, with gained knowledge, we can state, that it has better preconditions for effective processing of death and wedding historic records.
|
|
Web application for the detection system of risk situations at the railway crossing
Bachorec, Jan ; Malina, Lukáš (referee) ; Martinásek, Zdeněk (advisor)
The thesis deals with the complete design, development and implementation of the server solution and graphical user interface for an autonomous system for detecting risk situations at a railway crossing. The server solution consists of a server service and a database. The .NET Core platform was used to develop the server service and its purpose is to perform the collection, processing and storage of information about risky traffic situations recorded by the camera modules. The service uses a Cassandra cluster database for secure data storage, and the database schema was designed with a focus on high performance. The own user interface is implemented with a web application built on Razor Pages technology. This application presents recorded traffic incidents to the user, using its own REST API service as a data source. REST API implements all logical operations on the data in the database.
|
| |
| |
|
Completion and Optimization of a Temporal Extension for PostgreSQL
Koroncziová, Dominika ; Bartík, Vladimír (referee) ; Rychlý, Marek (advisor)
This thesis focuses on a implemenation of a a temporal data support within traditional relational environment of PostgreSQL system. I pick up on Radek Jelínek's thesis and an extension developed by him. I've analyzed the extension from functional, practical and performance perspectives. Based on my results, I've designed and implemented changes to the original extension. The work also contains implementation details as well as performance comparison results between the new and the original extensions.
|
| |